CREATE TABLE [dbo].[628mva]
(
[FUND NUMBER] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FUND NAME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MANAGEMENT NAME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BASE CURRENCY CODE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAGE NUMBER] [float] NULL,
[AS-OF DATE] [datetime] NULL,
[REPORT TITLE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SECURITY TYPE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SECURITY CATEGORY/ACTION] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOCAL CURRENCY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TRADE COUNTRY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXCHANGE RATE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAJOR INDUSTRY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MINOR INDUSTRY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TICKER] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ASSET ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ASSET DESCRIPTION] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COUPON RATE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MATURITY DATE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STRIKE PRICE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CALL/PUT INDICATOR] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISSUE DESCRIPTION] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXPIRATION DATE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UNITS] [float] NULL,
[LOCAL UNIT COST] [float] NULL,
[LOCAL TOTAL COST] [float] NULL,
[LOCAL UNIT PRICE] [float] NULL,
[LOCAL MARKET VALUE] [float] NULL,
[% OF CURRENCY] [float] NULL,
[LOCAL UNREALIZED GAIN LOSS] [float] NULL,
[UNDERLYING FUND #] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ORIGINAL FACE (UNITS)] [float] NULL,
[BASE UNIT COST] [float] NULL,
[BASE TOTAL COST] [float] NULL,
[BASE UNIT PRICE] [float] NULL,
[BASE MARKET VALUE] [float] NULL,
[% FUND] [float] NULL,
[BASE UNREALIZED GAIN LOSS] [float] NULL,
[App] [float] NULL,
[Dep] [float] NULL
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'VirtualFolder', N'MVA Stuff', 'SCHEMA', N'dbo', 'TABLE', N'628mva', NULL, NULL
GO
